CREATE TABLE [dbo].[TriggerTable](
	[Id] [bigint] NOT NULL,
	[TableName] [nvarchar](100) NOT NULL,
	[TableColumn] [nvarchar](100) NOT NULL,
	[TableId] [nvarchar](100) NOT NULL,
	[Command] [nvarchar](20) NOT NULL,
	[Aktarildi] [bit] NOT NULL,
 CONSTRAINT [PK_TriggerTable] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[TriggerTable] ADD  CONSTRAINT [TriggerTable_Aktarildi]  DEFAULT ((0)) FOR [Aktarildi]
GO

/////////////////////////////////////////////////////////////////////////////////////////////

CREATE TABLE [dbo].[TBLPOSPUANACIKLAMA](
	[Id] [int] IDENTITY(100,1) NOT NULL,
	[PIND] [int] NOT NULL,
	[ACIKLAMA] [nvarchar](150) NOT NULL,
	[Aktarildi] [bit] NOT NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[TBLPOSPUANACIKLAMA] ADD  CONSTRAINT [TBLPOSPUANACIKLAMA_Aktarildi]  DEFAULT ((0)) FOR [Aktarildi]
GO

//////////////////////////////////////////////////////////////////////////////////////////////

CREATE TABLE [dbo].[TBLPOSPUAN](
	[Id] [int] IDENTITY(100,1) NOT NULL,
	[TARIH] [datetime] NULL,
	[BELGENO] [nvarchar](10) NULL,
	[CARIIND] [int] NULL,
	[PUAN] [decimal](28, 8) NULL,
	[BELGETIPI] [int] NULL,
	[BELGEIND] [int] NULL,
	[AKTARILDI] [int] NULL,
	[Aktarildi] [bit] NOT NULL,
 CONSTRAINT [PK_TBLPOSPUAN] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[TBLPOSPUAN] ADD  CONSTRAINT [TBLPOSPUAN_Aktarildi]  DEFAULT ((0)) FOR [Aktarildi]
GO

///////////////////////////////////////////////////////////////////////////////////////////////

CREATE TABLE [dbo].[TBLPBIPUANYETKI](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[USERNO] [decimal](18, 0) NULL,
	[YETKI] [decimal](18, 0) NULL,
	[ACIKLAMA] [nvarchar](50) NULL,
	[Aktarildi] [bit] NOT NULL,
 CONSTRAINT [PK_TBLPBIPUANYETKI] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[TBLPBIPUANYETKI] ADD  CONSTRAINT [TBLPBIPUANYETKI_Aktarildi]  DEFAULT ((0)) FOR [Aktarildi]
GO

/////////////////////////////////////////////////////////////////////////////////////////////////

CREATE TABLE [dbo].[SyncTable](
	[Id] [bigint] IDENTITY(1,1) NOT NULL,
	[TableId] [bigint] NOT NULL,
	[Aktarildi] [bit] NOT NULL,
 CONSTRAINT [PK_SyncTable] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[SyncTable] ADD  CONSTRAINT [SyncTable_Aktarildi]  DEFAULT ((0)) FOR [Aktarildi]
GO

